website-hero-image2

2580 Lead Data Engineer

Location: Beaverton, OR

Description:
Our client is one of the local leaders in the Software Consulting business. Your experience as a Data Professional will be directly helping a major local company achieve and complete their software initiatives. If working in a consultative/agency organization helping to complete projects and creating custom software solutions excites you, please send your resume to careers@itmotives.com. We value and encourage diversity in the workplace and women, minorities, and veterans are highly encouraged to apply. Thank you.

Job Type: FTE

Additional Information:
The Role
We’re a software consulting and engineering firm in Beaverton, OR, seeking a Data Engineering Tech Lead. In this highly visible role, you will serve as the technical expert responsible for design and implementation of BI, Analytics, & Big Data solutions providing high-value, timely analytics and data solutions to customers. You will be responsible for verifying requirements, defining architecture, developing an implementation plan, providing thought leadership for all data solutions, including designing data solutions that meet and exceed customer expectations.

You will also provide direction to developers overseeing the development, unit testing and documentation for the developed solution and develop strong customer relationships for ongoing business. For success in this role, you will be experienced with the Cloud-based Data Solution Architectures, Software Development Life Cycle (including both Agile & Waterfall), Data Engineering and ETL tools/platforms, and data modeling practices.

Responsibilities
• Manage the development of Data Engineering Solutions including Data Lake / Data Warehouse / Business Intelligence solutions
• Develop Analytics/BI Solutions providing developed solutions as well as hand’s-on guidance to the project team members
• Serve as a thought leader & expert on Analytics/BI tools
• Develop relational models, cubes and reports in a re-usable fashion aligned with the architectural direction
• Work closely with the deployment team to ensure all developed solutions are aligned to design documentation and customer requirements
• Mentor fellow Analytics Developers/Team Members/Clients
• Analyze customer’s business needs and information requirements, define optimum system requirements to meet business needs, and be able to prioritize and manage new, in-line requirements
• Provide hands-on problem-solving assistance with data integration and data profiling tools to developers.

Experience we’d ideally like to see
• Bachelor's degree Computer Science, Management Information Systems, or equivalent
• 7+ years Deep Experience with RDBMS systems and data warehousing with an Expert Level understanding of BI/DW architecture, Cloud Solution Architecture (AWS and/or Azure), and Performance Standards/Tuning, with Certifications being a plus
• 5+ years of experience in data modeling (logical and/or physical), ETL design, reporting design
• Deep Experience with a variety of ETL/Data Solution tools such as AWS Data Pipeline, Azure Data Factory, AWS Redshift, Informatica, SSIS, etc
• Strong to Expert level SQL & Python skills
• Deep Experience with both structured & unstructured data
• Deep Experience with Relational (SQL Server, Oracle, MySQL, etc) & No-SQL databases (Cassandra, MongoDB, Hadoop, etc)
• Experience developing RESTful API’s to enable data consumption
• Demonstrated ability & strong interest in learning new technologies
• Experience with relational and dimensional data modeling approaches
• Excellent written and verbal communication skills required

Some extra’s we’d like to see
• At least 1-3 years Consulting or IS Consulting Experience Understanding of core Business Intelligence (BI)/data warehousing technology: RDBMS, Web, Client/ Server, and OLAP Skills
• Experience with Stream/Messaging/Workflow management a plus (i.e. Apache Airflow, Kinesis, Kafka, Spark, etc.)
• Experience developing API integrations/embedding of Reporting Tool visualizations (i.e. Tableau, Power BI, etc.)
• Experience solving business problems by applying analytics techniques such as machine learning and statistical modeling using analytical tools and programming languages
• Experience with R, SAS, Jump, or similar Statistical Modeling software
• Experience with Object Oriented development methods
• Programming experience (.Net, Visual Basic, C, C++); Web/Internet experience (JAVA, HTML, ASP, XML, XSL)

Those that tend to do well here
• Work well in team-oriented environments and enjoy collaboration
• Provide technical and cultural “lift” to the team
• Are good at “figuring stuff out” when everything is not well explained or known
• Good with ambiguity
• Understand who to ask and what to ask
• Self starters who take the initiative
• Able to work independently with minimal guidance