OVERVIEWAssociation Analytics is the leading analytics solution provider in the association space. Our Analytics Engineers work at the intersection of business and data, and are the key technical staff members responsible for bringing our cloud-based analytics platform - Acumen - to life. As an Analytics Engineer you will be on a small team working directly with customers to translate their business needs and analytical requirements into working data products. A successful Analytics Engineer can work with teams of technical and non-technical stakeholders to deliver analytical solutions that meet our customer's business needs.This role can be in the Arlington, VA HQ 2 days per week.KEY AREAS OF RESPONSIBILITYAn Analytics Engineer is responsible for the technical success of their client analytics projects. As the technical backbone of a small team of people with diverse skillsets you will own the process of developing analytical products for our customers, receiving inputs and assistance from others on the team along the way. Our customers will rely on you as their technical point of contact within Association Analytics and will lean on you for support and guidance throughout their analytics journey.You will work closely with business teams to identify client requirements, providing technical input and validation during all phases of the delivery process. Analytics Engineers are highly encouraged to initiate or contribute to technical projects that remove barriers to delivery, especially so if it would help other teams solve a common problem.JOB DUTIES
- Attending requirement gathering calls with customers alongside your team members and provide technical inputs as necessary.
- Designing, authoring, and maintaining data transformations written in Redshift SQL and dbt.
- Contributing models, documentation, and tests to our set of dbt packages.
- Contributing all new code to source control.
- Contribute data orchestration pipelines (DAGs) to Airflow.
- Performing quality control checks and validations on ETL pipelines.
- Deploying, configuring, and customizing Power BI datasets and reports.
- Fixing data issues raised by customers.
- Communicating frequently with your team and any project stakeholders.
- Performing code reviews for your peers.
- Monitoring dbt and PowerBI for pipeline refresh issues and responding to incidents as necessary.
SUCCESS FACTORS
- Results Focused. You are driven to meet or exceed your goals and objectives on schedule and will apply all the resources at your disposal to do so in creative ways. You can work with a team to get stuff done even when you disagree about the best way to do it.
- Technical Excellence. You know a lot about technology and how to make it work for you. You are continuously striving to improve your knowledge and skills. You pay close attention to detail and have a strong commitment to quality. You can decompose complex technical issues quickly under pressure with minimal help/supervision and have a good sense for when it's time to rope in others.
- Truth Seeking. When faced with ambiguity, you dedicate yourself to uncovering and understanding the objective reality without relying on others. You value accuracy in your pursuit of the truth.
- Ownership. When you are asked to solve a problem, you invest yourself fully in making sure it gets done right. You don't pass problems on to others if you know you can solve them yourself.
- Communication. You can clearly and succinctly communicate ideas and problems professionally to all levels within the organization, including executive leadership. You can build consensus in many cases and provide convincing evidence and reasoning in other cases.
- Change Management. You understand the value in change management. You follow all established change management guidelines. You can rally your team around best practices, new processes, and new tools related to change management.
- Flexibility. You are open to changing priorities in a fast-paced, startup environment yet still able to balance compressed timelines while providing the highest levels of customer service to your internal stakeholders.
- Organization. You can prioritize essential components of a project and let go of unnecessary work you are exposed to.
PREFERRED SKILLS AND QUALIFICATIONS
- Bachelor's Degree in Computer Science, Mathematics, or related field
- Experience with cloud data warehouse technologies (preferably Amazon Redshift)
- Experience with data modeling concepts as they apply to data warehouses
- Ability to communicate effectively with both technical and business teams
- Self-managing with the ability to make good decisions in the absence of complete information
- Hands on experience with data transformation tools (preferably dbt)
- Hands on experience with source control systems (preferably git/Github)
- Hands on experience with BI systems (preferably Microsoft Power BI)
- 2+ years of experience writing SQL
- 2+ years of experience with ETL pipelines
- 2+ years of experience building reports, notebooks, and/or dashboards in a data visualization tool
- Working knowledge of cloud technologies (preferably AWS)
- Experience building project plans to identify tasks, milestones, and deliverables
Career Path
- Junior Analytics Engineer (new grad)
- Analytics Engineer
- Senior Analytics Engineer
- Lead Analytics Engineer (management path)
- Principal Analytics Engineer (technical path)