Data Warehouse Engineer
New York, NY

Job Description

Are you our next Mimiac?

Mimiac {mi-mee·ak} noun

1. A smart, enthusiastic and overly zealous person who loves working at Mimeo.

SUMMARY:

As a Data Warehouse Engineer, you will support the enterprise by designing and delivering data reporting solutions, overseeing ETL processes, maintaining related documentation and carrying out work related to development, transfer, verification, security, integrity, manipulation and maintenance of all data assets, including the company's proprietary databases. You will be instrumental in formulating and executing strategy designing, architecting, deploying and maintaining business intelligence (BI) reporting methodologies using Modern Data Warehousing concepts.

KEY RESPONSIBILITIES:

● Participate in the design and implementation of innovative database systems and applications including the deployment of Modern Data Warehousing methodology via cloud-based topography.

● Design, build and maintain various integration packages and ETL processes between internal and external systems and data sources, including but not limited to ERP applications (ex. Microsoft Dynamics AX) and CRM applications (Salesforce, Freshsales) and other downstream applications necessary to support the enterprise using industry standards and best practices.

● Provide data extracts, ad hoc financial and management reports, and other data and analytical requests.

● Provide technical support for the data transfer process in coordination with internal and external IT resources.

● Ensure consistent data integrity, including writing necessary programs to transform, verify, and correct data, creating custom reports, configuring and monitoring data change management, formatting data for ease of use and continuous improvement of database functionality.

● Develop and maintain accurate, timely, comprehensive documentation for databases and applications.

● Research and report on emerging data sources, methodologies and emerging technologies as directed.

● Other duties as assigned.

SKILLS AND QUALIFICATIONS:

● Bachelor's Degree in Computer Science or Management Information Systems or equivalent required.

● Minimum of five years' experience in a technical environment, managing very large, complex data sets and database systems.

● Proficiency in the following is required: MS Reporting Services, MS Integration Services, MS Analysis Services, SQL Server 2008 and up, Powershell, Advanced T-SQL, VB.NET (or C#), PowerBi or comparable data presentation and analytical tool, and MS Excel.

● Ability to create complex ETL/SQL scripts to load data to and from on-premise and cloud data sources (preferably Azure SQL DW).

● Hands on experience with Azure SQL DW, Blob Storage, CI/CD pipeline, Data Factory v1 and v2, Data Lake.

● Experience working with, and designing, solutions and methodologies for Modern Data Warehousing in Azure, with an in-depth understanding of Data Warehousing concepts, dimensional data models and experience in creating data warehouse schemas

● Must be able to successfully work on multiple projects simultaneously and work under tight deadlines in a results-oriented environment.

● Must have excellent organizational, project management, communication skills, and comprehension skills.

● Outstanding interpersonal skills, including the ability to use influence to build consensus at all levels.

● Ability to work flexible extended hours, evenings and weekends, if required.

● Excellent verbal and written communication skills.

● Must display a strong personal commitment to achieving.

● Must be highly energetic, creative and display high enthusiasm and a self-starter.

COMPETENCIES:

● Technical Expertise: Commands requisite knowledge, skills, and experiences to execute role-specific accountabilities and tasking.

● Problem Solving: Overcomes obstacles to address the cause and to drive progress.

● Data Analysis: Leverages analytical tools to assess the business, draw conclusions, and make recommendations.

● Prioritization & Continuous Improvement: Focuses efforts on results-oriented activities to optimize personal and organizational effectiveness.

● Innovative Thinking: Develops novel, value-creating solutions that improve business results.

● Attention to Detail: Delivers professional, error-free, high-quality work that consistently meets and exceeds expectations.

● Passion: Exhibits passion for the organization, the business, and goal achievement. Serves as a source of inspiration to others.

Mimeo is an Equal Opportunity Employer (EOE). Our employment decisions are made without regard to race, color, religion, sex, marital status, pregnancy, national origin, citizenship, age, physical or mental disability, genetic information, sexual orientation, veteran status, military status, or any other characteristic or status protected by federal, state, or local law. If you need assistance or an accommodation during the application process due to a disability, it is available upon request.