Consultant
at Twocircles
New York, United States, mid, full time, USD 70,000–95,000 / year, 3–5 years
seen 4d ago
- S3
- Business Intelligence
- Power BI
- AWS Redshift
- PostgreSQL
- AWS Athena
- AWS Glue
- Tableau
- SQL Server
- Microsoft Dynamics
- ELT
- Looker
- SQL
- R
- Relational Databases
- MySQL
- Data Visualization
- Data Modeling
- ETL
- AWS
- Python
- Salesforce
About the role
The role will require the candidate to be responsible for:
Analyzing Business Needs and Providing Data-Driven Solutions
* Work closely with clients to understand their business objectives, technical requirements, and data challenges.
* Translate business needs into technical solutions, identifying opportunities to leverage data, analytics, and automation to optimize processes, improve performance, and drive growth.
* Independently develop and implement tailored analytical solutions that align with client objectives and technical environments.
SQL Development, Database Management & Data Integration
* Develop, optimize, and troubleshoot complex SQL queries, database views, and data models to support reporting, business intelligence, and advanced analytics.
* Work with large datasets across relational databases and cloud-based data warehouses, ensuring efficient data structures, query performance, and data integrity.
* Integrate, transform, and validate data from multiple sources, supporting data quality initiatives and collaborating with technical teams on data pipelines and ETL/ELT processes.
Conducting Advanced Data Analysis and Modelling
* Collect, clean, transform, and analyze complex datasets from multiple sources to identify trends, patterns, and actionable insights.
* Apply analytical techniques to support business use cases such as customer segmentation, fan engagement analysis, lead scoring, and customer lifetime value.
* Support the development of predictive models and statistical analyses, leveraging SQL and, where applicable, Python or other analytical tools to develop repeatable and scalable solutions.
Business Intelligence, Data Visualization & Communication
* Design, develop, and maintain dashboards, reports, and data visualizations using Tableau, Power BI, or similar business intelligence platforms.
* Develop underlying data models, SQL queries, and calculations to support accurate reporting, while identifying opportunities to automate and optimize analytical processes.
* Translate complex analytical findings into clear, actionable insights and strategic recommendations, effectively communicating results to technical and non-technical stakeholders.
Read from twocircles.com, last seen 4d ago.