Be an early applicantLess than 25 applicantsPosted by Agency

Company

ACS Consultancy Services, Inc · 6 hours ago

Business Intelligence Developer

United States

Full-time

Remote

Mid Level

Maximize your interview chances

ConsultingInformation Services

No H1B

U.S. Citizen Only

Security Clearance Required

Insider Connection @ACS Consultancy Services, Inc

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Gather and understand business requirements to design and develop BI solutions.

Design, develop, and maintain dashboards, reports, and visualizations.

Translate complex data into meaningful and easy-to-understand formats for business stakeholders.

Design and implement Extract, Transform, and Load (ETL) processes to ensure data is correctly integrated into data warehouses.

Perform data cleansing, transformation, and aggregation to ensure accuracy and consistency.

Build and maintain data models, including dimensional models and relational schemas, to ensure data integrity and accessibility.

Create and optimize complex SQL queries to retrieve, manipulate, and analyze data.

Work closely with business analysts, data architects, and other stakeholders to understand reporting needs and data requirements.

Provide technical expertise in BI tools and methodologies to non-technical users.

Ensure the efficient storage, retrieval, and processing of data in databases.

Monitor and optimize database performance and query execution times.

Stay current with emerging BI technologies and best practices.

Proactively suggest improvements for BI solutions to enhance business intelligence capabilities.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

BI solutionsETL processesSQLAgile methodologyPythonJavaOracleJIRAMS ProjectTOGAFITILCBAPERP systemsCloud computingEnterprise systems integrationCollaborative team environment

Required

Bachelor's degree in Computer Science, Information Systems, Business Administration, or a related field.

Experience as a Systems Analyst or in a similar IT role.

Proficiency in system analysis, database management, and system design tools.

Familiarity with software development life cycle (SDLC) methodologies, such as Agile and Waterfall.

Knowledge of programming languages (e.g., Java, Python), database management systems (e.g., SQL, Oracle), and project management software (e.g., JIRA, MS Project).

Strong problem-solving abilities and attention to detail.

Excellent verbal and written communication skills, with the ability to convey technical concepts to non-technical stakeholders.

Ability to work effectively in a collaborative team environment and engage with stakeholders at all levels of the organization.

Required Security clearance.

Preferred

Certifications in relevant technologies or methodologies (e.g., TOGAF, ITIL, CBAP).

Experience with ERP systems, cloud computing, or enterprise systems integration.

Experience with Agile or Scrum methodologies.

Federal Experience is a plus.

Company

ACS Consultancy Services, Inc

ACS Consultancy Services Inc is a Small Business that is New York State and New York City Certified Minority and Women-Owned Business Enterprise (MWBE).

Founded in 2011