Vacancy expired!
Location: Boston, MA Salary: Dependent on Experience Description: Our client is currently seeking a Senior Data Engineer, BI. The Data Engineer is a technical role with SQL Server and Azure cloud data technology at its core and has ample opportunity for technical growth as we move from traditional data technologies to cloud data architecture. As the company takes on new challenges in areas like supply chain and digital, this role will be highly involved in ensuring our data platform is scalable, performant, and ready for the future.
This job will have the following responsibilities:- Build out and migration to cloud data technologies, which may include (but not limited to) Azure Data Lake, Azure SQL Pools, Apache Spark, Synapse, Azure Data Factory
- SQL Server Database development work including tables, views, stored procedures and functions. SSIS development for Extract Transform Load (ETL) processes as well
- Performance tuning and testing of BI structures and processes
- Participation in the design of data models to house and deliver essential reporting
- Automation with Powershell Scripting
- Consultation with other IT personnel to perform essential analysis on source data
- Collaborate with BI Team members and key BI power users on specific data designs and intended use
- Collaborate on requirements definition, design and build out of key data warehousing and integration deliverables for Supply Chain, Brand Insights, Digital, Sales and other areas
- SQL scripting to perform essential data maintenance functions including reclassifications, some master data setup and other
- This role may also be involved in data preparation and modeling using the Power BI platform as well as Analysis Services-Tabular
- Maintenance and extension of our SQL server jobs and Azure PowerShell runbooks for update of our SQL and Azure environments
- Partner with the BI team to promote and evolve design, development, and testing standards
- Adhere to IT department policies and procedures when performing tasks to ensure controls are in place and departmental goals are met. Adhere to standards for testing, documentation, and change management
- Occasional travel may be required (
- Bachelor's degree in computer science or equivalent relevant experience.
- Data Engineer: 3+ years in a data integration or data warehouse development role, preferably in a Microsoft environment
- Senior Data Engineer: 5+ years in a data integration or data warehouse development role, preferably in a Microsoft environment
- 3+ years hands-on development experience with SQL Server, SSIS, SSAS
- 1+ years working with Azure cloud data technologies including migration, integration, and design Powershell scripting experience
- Working conditions: Occasional travel may be required (
- Preferred Qualifications:
- Microsoft SQL Server, Azure data technologies, Power BI training and certification all a plus.
- Microsoft Power BI platform, including DAX and Power Query expressions and Analysis Services tabular a big plus
- Python scripting a plus
- MuleSoft, SAP Hana data experience helpful
- Other cloud platforms such as AWS a plus
Vacancy expired!