The Senior Data Engineer Consultant is an English speaking role as part of the North America Technology Services team with comprehensive and in-depth knowledge of business use cases, technical concepts, practices and procedures related to preparing data for analytical usage.
This role will work with both the IT and business side of the customer’s organization to understand their business goals and be responsible for designing and implementing impactful analytics solutions to address these goals. As an individual you will be responsible for creating, expanding and optimizing data sets and data pipelines, as well as optimizing data collection and workflows in the customer’s environment both on-premises and on cloud. As a senior member of the team you will be the primary analytics technical lead for the architecture principles, design concepts, standards, product selection and thought leadership for the rest of the Data Platform and Analytics team and also in our cross-functional services team. As a Data Platforms and Analytics consultant, it is important that you are excited to work with data and enjoy optimizing data systems and building them from the ground up or even re-designing the customer’s data architecture to support the next generation of products and data initiatives in the market.
Roles & Responsibilities:
Analyze customer's overall data estate, IT and business priorities and success measures to translate into functional architectures and solutions
Apply technical knowledge and customer insights to create a data analytics roadmap and architect solutions to meet business and IT needs, ensuring technical viability of new projects and successful deployments, orchestrating key resources and infusing key data technologies
Design and develop data platform and data models that will enable analyzing data to gain insights. This includes the creation of logical and physical Data Models including data warehouse and data mart.
Developing and Optimizing ETL (ELT) platform and processes to ingest and integrate structured/unstructured data from diverse sources.
Use analytical and statistical rigor to solve complex problems and drive business decisions.
Responsible for maintaining, supporting and improving on an on-going basis the services and components within the data platform and analytics team.
Maintain and advance deep technical skills and knowledge, keeping up to date with market trends and competitive insights, and share within the technical community.
Support Sales with presales discussions and technical design for bid.
What we need to see from you
Technical Skill / Product Knowledge Breadth of technical experience and knowledge in the following areas: Commercial and Open Source on-premises and in cloud, Database architecture, ETL, Data Mining, Business Intelligence, Big Data, Data Governance and Reports/Visualization.Deep understanding of Microsoft data platform technologies on Azure, AWS and on-premises such as SQL Server, SSIS, SSAS, Data Factory, Azure SQL DB, Cosmos DB, Azure Synapse Analytics, etc.Technical Experience with other market leading data platforms that exist on premises, Azure and AWS such as Oracle, DB2, MySQL, Snowflake, and RedShift.Experience with relational and non-relation (NoSQL) database as well as big data systems and servicesTechnical expertise and knowledge of data cleaning, wrangling, visualization and reporting, with an understanding of the best practices and the most efficient use of tools/applications to complete these tasks.Technical expertise building and optimizing workflows for large amounts of structured and unstructured data, including integrating data from multiple sources, data lake architecture, business intelligence pipelines using various ETL (ELT) tools and data visualization tools such as Power BI or Tableau.Proficient in data modeling, ETL (ELT) development, Data warehousing and Master Data Management (MDM).Proficient in SQL, Python, Spark SQL, Databricks, Azure Data Lake, Azure Data Factory, Azure Analysis Services.Experience with real time data processing in high volume transactional environment.Ability to evaluate requirements and technical specifications for solution design fit. Other skills and Requirements Great presentation and communication skills, and ability to communicate with multiple audiences (business, technical, legal).Demonstrated ability to adapt to new technologies and learn quickly.Experience working with North America clientsProblem-solving aptitude. Strong analytic, problem solving and critical thinking skills.Project and Product Management.Travel required up to 50%.Experience in leading teams and training.Maintain and acquire advanced level technical certification in assigned area and maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies. Knowledge, Skills and Abilities Required: University degree preferred (in the field of Information Technology and/or or equivalent combination of experience and education; Master’s degree preferred).8+ years or equivalent experience designing and implementing analytics solutions with on-premises and cloud-based technologies, including relational and non-relational databases, data warehouse, master data management, big data and orchestration tools.5+ years or equivalent experience in a Data Engineer Consulting/Architecture position within a software and/or services company.Documented successful deployments of enterprise-wide advanced data platform use casesAdvanced-level Technical Certifications required.Ability to independently conduct meetings with: end user level, engineering-level, management-level or executive level customer personnel in regard to positioning sales and solutions.
What you should really know about us.
Strip away everything. Strip away our brand, strip away our buildings, strip away our offices. What are we left with? Our people. This is what makes SoftwareONE successful. Passionate people who live and breathe our values every day, who delight our customers, every day, and who go above and beyond, every day. Our culture is unique, and I believe that having the right people, and empowering them to succeed, is the absolute key to our success. Patrick Winter, Founder.
What we expect from our employees
Success at SoftwareONE is not defined by what you do for yourself, but by what you deliver for our customers, the business and for the employees around you. SoftwareONE employees are energized, agile and are laser focused on delivering world class Customer Satisfaction and results. Our leaders motivate and inspire their teams and provide a working environment that delivers incredible levels of Employee Satisfaction. We are Humble, have a very high degree of Integrity and are simply not interested in politics. Our leaders operate with a high levels of Discipline but are able to work at Speed manage change in a global economy.