Job Overview:
The qualified candidate will be responsible for designing and developing ETL, reporting, and BI solutions. Using Microsoft BI suite, responsibility will include data analysis and transformation, integration between the source applications, Operational and Enterprise Data Warehouses, Stores, and Marts, as well as deployment of the BI functionality to the business consumers.
• Ensure accuracy and integrity of the data and applications through analysis, coding, writing clear documentation and problem resolution.
• Analyze data content and ensure validity of the data structures in support of the ETL and BI needs.
• Analyze and translate functional specifications and change requests into technical specifications.
• Develop, test and implement program logic.
• Translate business requirements into end user applications.
• Works with Data Analyst to develop data warehouse models, design specifications, metadata process and documentation.
• Independently use development tools and utilities to develop, support, and customize moderately to highly complex business applications.
• Define, develop, document and maintain SSIS/SSRS packages, packages configuration and logging, and SSAS cubes.
• Define, develop, document and maintain procedural and SQL programs
• Assist in the development, execution and documentation of system and integration test plans.
• Perform ETL, reporting, and cubes tuning as well as SQL tuning.
• Optimize SSIS/SSRS/SSAS code performance and processing methods.
• Perform design validation, reconciliation and error handling in the load process (initial, incremental).
• Updates and maintains ETL Metadata.
• Provide input into standards and best practices for code development.
• Communicate status / risks regarding time and budget of the solution delivery.
Job Requirements:
• Bachelor’s degree specializing in computer science or equivalent work experience required
• 5+ years work experience in MS BI suite developing ETL and BI solutions utilizing the SSIS/SSRS/SSAS and MDX; experience with DAX preferred
• Experience with multiple programming languages preferred
• 5+ years work experience specializing in transforming XML, Flat files, or other delimited formats into RDBMS
• Good oral and written communication skills
• Strong initiative and organization skills
• Strong customer service and interpersonal skills
Contact Information:
Ryan Mac Donald
Senior Technical Recruiter
Saicon Consultants
9300 W 110th Street / Suite 650
Overland Park, KS 66210
rmacdonald@saiconinc.com
913-451-1178 Extension 14 – Work
913-522-0179 – Cell