Data Management Engineer
POSITION SUMMARY: Identifies data deficiencies, inconsistencies and duplications within internal databases. Develops processes to manage internal import/export and translation of data content. Configures, tunes and supports current SQL Server components including: SSRS, SSAS, SSIS. Develops accurate and secure custom reporting on Data Warehouse databases based on formal project management, application support requests, and project assignments. Requires the ability to take ownership and work well in a team environment.
ESSENTIAL FUNCTIONS:
- 4 - 6 years experience in developing business intelligence solutions with Microsoft business intelligence stack (SSIS, SSAS, and SSRS).
- Understanding and experience of data modeling, relational database architecture, and data warehouse development.
- Expert in constructing complex T-SQL queries using multi-table joins, CTEs, sub-queries, views, window functions, user defined functions (UDFs), and stored procedures in a production environment.
- Professional experience in performance tuning against slow queries involving complex table joins and large volume of data.
- Expert experience in building complex ETL packages with SSIS, by implementing ETL framework and data transformations such as data conversion, conditional split, derived columns, merge and lookup etc., and loading into production CRM databases and data warehouses.
- Demonstrated skills in ETL package deployment to production and process automation using SQL Server Agent to schedule jobs on regular basis.
- Expert in designing and implementing dashboard reports utilizing Tableau and PowerBI.
- Proven expertise in SSRS to generate ad-hoc reports and dynamic reports featuring KPIs, dashboards, drill-down, and drill-through using parameters and expressions.
- Experience in designing and creating OLAP Cubes with SSAS, querying and generating reports using MDX language, and implementing KPI objects.
- Strong team player with great problem-solving skills, verbal, written communication and interpersonal skills. Willing to take responsibilities.
COMPETENCIES:
- Business or Technical Acumen
- Fast & Flexible
- Focus on Results
- Teamwork & Collaboration
- Ethics & Values
- Self Awareness/Personal Accountability
- Informing and Communicating
EDUCATION: B.S. or equivalent experience/technical training.
EXPERIENCE:
- Languages: SQL, T-SQL, PL/SQL, MDX, C#
- Databases: SQL server 2012/2014/2016/2017, Oracle 10g/11g
- Software: SQL server BI Stack (SSIS, SSAS, SSRS), Visual Studio 2016, SharePoint, Team Foundation Server (TFS), Microsoft Office Suite
- ETL Tools: SSIS, Import/Export Data, Bulk Insert, BCP, Database Replication, Streaming
- Reporting Tools: SSRS, Tableau, PowerBI
- WORKING RELATIONSHIPS: Works in a team environment. Excellent oral and written communication skills.
- ADDITIONAL REQUIREMENTS: On call availability 24x7. Occasional travel required, sometimes on short notice.
- COMPLEXITY: Exercise independent judgment and act with some supervision in production environment. Work multiple simultaneous assignments and maintain flexibility and control in a changing environment. Must have excellent debugging, research, and problem solving skills.