The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
Mly26w732sffqz8k6dn

ETL & Business Intelligence Specialist

Job Description

 Data Analytics / Reporting:

  • Conduct data analysis in support of a variety of analytic solutions
  • Create and produce forecasts, reports, ad hoc requests, dashboards, etc.
  • Prepare monthly dashboard reports, identifying trends and presenting thoughtful, actionable solutions
  • Document and train end users on reports and dashboards

ETL / Data Blending:

  • Transform and utilize data in the data warehouse by creating, automating and documenting new tables in a post-load process.  These new tables will transform the data from transactional view to a more user-friendly business view.  These tables can be used for direct usage for descriptive and predictive analytics
  • Apply the business rules on raw data in the data warehouse, data cleansing, data blending to bring data into the shape for profiling, dashboards, insights via project basis
  • Applying masking routine on the personally identifiable / sensitive data when necessary
  • Continuously apply Data Governance processes including monitoring of the data quality with appropriate business areas
  • Provide data modeling, mining, pattern analysis, anomaly detection and data visualization to address customer needs with front-end tools
  • Documenting the data blending process along with the specifications and workflow/data lineage for future automation usage
  • Maintaining/adding to already made data dictionary for predictive analytics data profiling/modeling and/or any downstream usage
  • Partners with IT Database Administrators and business owners to ensure optimized data transformation and efficiencies
  • Develop relationships with business team members by being proactive, displaying an increasing understanding of the processes and by recommending innovative solutions

Job Requirements

Qualifications:

  • Bachelor's Degree in Computer Science / Engineering, IT, or Data Analytics from an accredited university
  • Hands-on proficiency in one or more scripting languages (e.g., Java, Python, Scala, R, Shell scripting)
  • 5+ years experience working with database an hands-on proficiency in SQL
  • 5+ years of relevant experience in ETL or data analyst role, including data mining and/or ETL development
  • 2+ years experience developing management reporting dashboards using Tableau
  • Database Development - Hadoop
  • Experience with relational databases: Sybase, ASE, SQL Server, Oracle, MySQL
  • Excellent written and verbal communication skills

Job Snapshot

Location US-NY-New York
Employment Type Contract to Hire
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

Atlantic Partners Co.

Atlantic Partners was created with the clear objective of providing the most comprehensive IT staffing solutions, along with a robust executive search division. From staff augmentation to contract for hire to direct placement, Atlantic Partners offers a full range of staffing options. With over 100 years of experience, our team of account executives and technical recruiters has a proven track record of fulfilling the human capital needs of our clients. Learn More

Contact Information

US-NY-New York
Joshua Smith
561-314-6742
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
Atlantic Partners Co.
Company:
US-NY-New York
Location:
Contract to Hire
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

 Data Analytics / Reporting:

  • Conduct data analysis in support of a variety of analytic solutions
  • Create and produce forecasts, reports, ad hoc requests, dashboards, etc.
  • Prepare monthly dashboard reports, identifying trends and presenting thoughtful, actionable solutions
  • Document and train end users on reports and dashboards

ETL / Data Blending:

  • Transform and utilize data in the data warehouse by creating, automating and documenting new tables in a post-load process.  These new tables will transform the data from transactional view to a more user-friendly business view.  These tables can be used for direct usage for descriptive and predictive analytics
  • Apply the business rules on raw data in the data warehouse, data cleansing, data blending to bring data into the shape for profiling, dashboards, insights via project basis
  • Applying masking routine on the personally identifiable / sensitive data when necessary
  • Continuously apply Data Governance processes including monitoring of the data quality with appropriate business areas
  • Provide data modeling, mining, pattern analysis, anomaly detection and data visualization to address customer needs with front-end tools
  • Documenting the data blending process along with the specifications and workflow/data lineage for future automation usage
  • Maintaining/adding to already made data dictionary for predictive analytics data profiling/modeling and/or any downstream usage
  • Partners with IT Database Administrators and business owners to ensure optimized data transformation and efficiencies
  • Develop relationships with business team members by being proactive, displaying an increasing understanding of the processes and by recommending innovative solutions

Job Requirements

Qualifications:

  • Bachelor's Degree in Computer Science / Engineering, IT, or Data Analytics from an accredited university
  • Hands-on proficiency in one or more scripting languages (e.g., Java, Python, Scala, R, Shell scripting)
  • 5+ years experience working with database an hands-on proficiency in SQL
  • 5+ years of relevant experience in ETL or data analyst role, including data mining and/or ETL development
  • 2+ years experience developing management reporting dashboards using Tableau
  • Database Development - Hadoop
  • Experience with relational databases: Sybase, ASE, SQL Server, Oracle, MySQL
  • Excellent written and verbal communication skills
Mwg7ln685bhyvvp7mpf
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
ETL & Business Intelligence Specialist Apply now