Lead Data Engineer(MicroStrategy)

Join OrangePeople as a Lead Data Engineer and be at the forefront of data transformation! In this role, you will design and manage advanced reporting solutions, optimize data flow and storage, and leverage AI, ML, and automation to drive innovation. You’ll analyze business needs, enhance data operations, and lead scalable projects while staying ahead of emerging technologies. If you're passionate about turning data into actionable insights and building systems that power exceptional user experiences, this opportunity is for you

Role Responsibilities:
• Lead the design, construction, and management of reporting solutions aimed at gathering, managing, and using both structured and unstructured data from various sources.
• Develop robust processes and structures to optimize data flow, routing, and storage, meticulously considering business and technical requirements, and deploying cloud and local storage solutions as necessary.
• Use advanced technical tools and programming expertise to implement data cleansing, organization, transformation, and maintenance tasks, integrating automation and innovative methodologies like big data, artificial intelligence, and machine learning as needed.
• Analyze internal and external business and product needs regarding data operations, suggesting adjustments and improvements to systems and storage to keep up with ongoing demands.
• Help engage around the estimation and planning of highly sophisticated scalable projects and their budget allocations.
• You will be expected to stay up to date with emerging technologies so you can make informed recommendations.
• May be required to provide support escalation, coordinate the ongoing operations, and support the enhancement of existing tools as needed.

Internal/Temporary Assignment
• This is an internal assignment with no guarantee of permanent placement.

Basic Qualifications:
• Minimum 7 years of related work experience.
• Advanced development skills in cross-platform coding languages such as SQL/TSQL, Python, Java, and VBA.
• SQL and scripting expertise for data extraction, transformation, and building performant datasets, with a focus on automation.
• Extensive experience with relational databases and NoSQL databases (e.g., Snowflake, SQL Server, Oracle, MongoDB,).
• Comfortable working in an agile environment, collaborating with cross-functional teams, and adapting to changing requirements.
• KEY: Expert in MicroStrategy report and dashboard development, with a desire to further develop technical expertise in data engineering tools, methodologies, and emerging technologies.
• Other notes: This is a very large transition project; Relational database; Hit the ground running; Working with a customizable platform that is a primary reservation system.

Preferred Qualifications:
• Queuing Technology – Kafka, RabbitMQ, Redis, SQS, Kinesis Streams, Kinesis Firehose.
• Data Processing – EMR, Spark, Glue, Spark Streaming/Flink.
• Containers - Docker, Docker Swarm, Docker Applications.
• CICD - Jenkins/Codebuild/GitLab.
• Security - IAM roles, wire encryption, KMS, Kerberos, Authz, AD.
• Infrastructure as Code - Terraform, Cloud Formation, CDK.
• Proficient in cloud technologies including AWS (e.g., Lambda, Kinesis, DMS, AppFlow).

Required Education:
• Bachelors or Equivalent Experience.

Benefits:
• 401(k).
• Dental Insurance.
• Health insurance.
• Vision insurance.
• We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
• The salary will be determined based on several factors including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.

Additional Responsibilities:
• Participate in OrangePeople monthly team meetings, and participate in team-building efforts.
• Contribute to OrangePeople technical discussions, peer reviews, etc.
• Contribute content and collaborate via the OP-Wiki/Knowledge Base.
• Provide status reports to OP Account Management as requested.

About us:

OrangePeople is an Enterprise Architecture and Project Management solutions company. Our most valuable asset is our people: dynamic, creative thinkers, who are passionate about doing quality work. As a member of the OrangePeople team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & and education. An ideal Orange Person is a technology leader with a proven track record of technical achievements and a strong process/methodology orientation.