Senior Data Engineer

Data Engineer Location: Remote (Must be in the United States) Employment Type: Long-term Contract Compensation: $75-85/hr Brooksource is hiring a Data Engineer for a leader in waste management and sustainability located in Arizona. As a Data Engineer, you will be hands-on technical with a focus on full stack software development within a Enterprise Data organization. The role will play curtail part in shaping future big data and analytics initiatives. PRINCIPAL RESPONSIBILITIES: • Designs and develops code and data pipelines to ingest from relational databases (Oracle, SQL Server, DB2, Aurora), file shares, and web services. • Build Data Lake on AWS S3 with optimal performance considerations by partitioning and compressing data. • Data Engineering and Analytics using AWS Glue, Informatica, EMR, Spark, Athena, Python. • Data modeling and building Data Warehouse using Snowflake, DBT. • Designs and develops code and data pipelines to ingest relational databases, file shares, and web services. • Participates in requirements definition, system architecture design, and data architecture design. • Participates in all aspects of the software life cycle using Agile development methodologies. • Experience designing and implementing Medallion Architecture (Bronze, Silver, Gold layers) for enterprise data platforms. • Hands-on experience with SQLDBM for data modeling, schema design, and data warehouse architecture documentation. • Experience developing conceptual, logical, and physical data models using SQLDBM and collaborating with business and technical stakeholders on model reviews. MINIMUM QUALIFICATIONS: • Bachelor’s degree in computer science, Computer Information Systems, Engineering, Statistics or closely related field (willing to accept foreign education equivalent) (required). • Experience in AWS services for data and analytics (required). • 5 years of experience in Data Ingestion, Data Extraction, and Data Integration (required). PREFERRED QUALIFICATIONS: • 7+ years of experience in Enterprise Information Solution Architecture, Design, and development required. • 7+ years of experience with integration architectures such as SOA, Microservices, ETL or other integration technologies. • 7+ years of experience with working content or knowledge management systems, search engines, relational databases, NoSQL databases, ETL tools, geospatial systems, or semantic technology. • 5+ years of hands-on experience with AWS services (S3, Kinesis, Lambda, Athena, Glue, EMR) required. • 5+ years’ • Experience with JSON or XML data modeling required. • Experience with Git/GitHub, branching, and other modern source code management methodologies required. • Domain knowledge of NoSQL or relational database required. • Understanding of database architecture and performance implications required. • Experience integrating Business Intelligence applications like PowerBI. • Experience with Machine Learning and Artificial Intelligence. • Ability to multi-task effectively. • Ability to work collaboratively as part of an Agile Team. • Extensive knowledge and experience with Python and Snowflake Streamlit. • Excellent written and verbal communication skills, sense of ownership, urgency and drive. EEO Statement: Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc. Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.