What are the responsibilities and job description for the Senior Data Engineer position at BM Associates, Inc.?
Mandatory Qualifications:
1. This classification must have a minimum of seven (7) years of experience in electronic data processing systems study, design, and programming. At least four (4) years of that experience must have been in a lead capacity.
2. This classification requires possession of a Bachelor s Degree in an IT-related or Engineering field.
3. Experience in working with stakeholders and implementing end-to-end data solutions including data models, data pipelines and BI products to solve complex business requirements.
4. Experience in designing and implementing Data Warehouse architectures, Online Analytical Processing (OLAP) technologies, Star-schema, Snowflake schema and Aggregation Techniques.
5. Experience in maintaining the Data Warehouse structure to support the software development life cycle (SDLC) phases.
6. Experience in data warehousing/ETL tools, and Azure Data Factory (ADF) pipelines.
7. Experience with designing and implementing data extracts using Replication, Stored Procedures and SQL Server Integration Services (SSIS).
8. Experience with Data Warehouse concepts and architecture.
9. Experience writing SQL queries, stored procedures, indexing, debugging, optimization and database performance tuning and monitoring.
10. Experience producing requirements documents, systems architecture and interfaces, data model diagrams, configuration management documents, and procedural manuals.
Salary : $60 - $70