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

SQL Report Writer / Data Mart Builder

Job Description

SQL Report Writer / Data Mart Builder

BASIC FUNCTION:

  • Provide database and Extract, Transform and Load (ETL) development support and troubleshooting
  • Responsible for the completeness, consistency, and quality of organizational data
  • Lead, maintain, and troubleshoot Master Data Services mapping, SSIS, SSRS, SQL Server Integration Service applications, SQL Server Analysis Services, Visual Studio 2016
  • Design, develop, and automate company s reporting and KPI infrastructure for individual users, managers, executives and the CEO

Job Requirements

Required Skills:

  • 5+ years of experience with relational databases (Microsoft SQL and MySQL)5+ years of experience designing and building ETL
  • 5+ years of experience working with SSIS
  • 5+ years of experience in data analysis and database design.
  • 5 years of experience supporting data warehouse and business intelligence systems
  • Expert understanding of relational database design concepts
  • Strong experience with SQL queries, SSRS, SSIS, XML, Analysis Services, Power Query, HTML, DAX, MDX, Microsoft Office, SQL Reporting Services, Business Objects, Cognos
  • Experience supporting data warehouse projects and data cleanup for Business Intelligence and data visualization projects
  • Experience in data warehouse modeling, creation and maintenance of, DataMart, DataCube, data dimensioning and fact tables maintenance
  • Extensive analytical and problem solving skills
  • Experience in documenting data requirements
  • Experience in designing and developing reports directly in SQL and using report builder applications
  • Experience in source code version control techniques
  • Working knowledge of Tableau, Microsoft MDS, PowerBI, Sharepoint – nice to have
  • Demonstrated ability to design meaningful and immersive visualizations, dashboards, and reports that drive business insights
  • Familiarity building quality assurance reports
  • Experience with web services and establishing API connections
  • Self-motivated; willingness and ability to learn new technologies rapidly
  • Highly organized with strong attention to detail, time management skills and the ability to multitask
  • Ability to prioritize work on multiple competing projects to meet deadlines
  • The ability to work both independently and as a team
  • Outstanding customer service skills

Job Snapshot

Location US-MO-St. Louis
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

AIC (part of ACS Group)

Analysts International Corporation (AIC) is an IT services firm fully dedicated to the success and satisfaction of its customers. From IT staffing to project-based solutions, AIC provides a broad range of services designed to help businesses and government agencies drive value, control costs and deliver on the promise of a more efficient and productive enterprise. Learn More

Contact Information

US-MO-St. Louis
Vincent Godfrey
Icon-social-facebookIcon-social-linkedinIcon-social-twitter
Snapshot
AIC (part of ACS Group)
Company:
US-MO-St. Louis
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

SQL Report Writer / Data Mart Builder

BASIC FUNCTION:

  • Provide database and Extract, Transform and Load (ETL) development support and troubleshooting
  • Responsible for the completeness, consistency, and quality of organizational data
  • Lead, maintain, and troubleshoot Master Data Services mapping, SSIS, SSRS, SQL Server Integration Service applications, SQL Server Analysis Services, Visual Studio 2016
  • Design, develop, and automate company s reporting and KPI infrastructure for individual users, managers, executives and the CEO

Job Requirements

Required Skills:

  • 5+ years of experience with relational databases (Microsoft SQL and MySQL)5+ years of experience designing and building ETL
  • 5+ years of experience working with SSIS
  • 5+ years of experience in data analysis and database design.
  • 5 years of experience supporting data warehouse and business intelligence systems
  • Expert understanding of relational database design concepts
  • Strong experience with SQL queries, SSRS, SSIS, XML, Analysis Services, Power Query, HTML, DAX, MDX, Microsoft Office, SQL Reporting Services, Business Objects, Cognos
  • Experience supporting data warehouse projects and data cleanup for Business Intelligence and data visualization projects
  • Experience in data warehouse modeling, creation and maintenance of, DataMart, DataCube, data dimensioning and fact tables maintenance
  • Extensive analytical and problem solving skills
  • Experience in documenting data requirements
  • Experience in designing and developing reports directly in SQL and using report builder applications
  • Experience in source code version control techniques
  • Working knowledge of Tableau, Microsoft MDS, PowerBI, Sharepoint – nice to have
  • Demonstrated ability to design meaningful and immersive visualizations, dashboards, and reports that drive business insights
  • Familiarity building quality assurance reports
  • Experience with web services and establishing API connections
  • Self-motivated; willingness and ability to learn new technologies rapidly
  • Highly organized with strong attention to detail, time management skills and the ability to multitask
  • Ability to prioritize work on multiple competing projects to meet deadlines
  • The ability to work both independently and as a team
  • Outstanding customer service skills

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.
SQL Report Writer / Data Mart Builder Apply now