Job Family :
Data Science & Analysis Travel Required :
Up to 10% Clearance Required :
Ability to Obtain Top Secret (TS) What You Will Do : * Building apps, flows, and data storage solutions to drive IT Construction business processes all within the power platform suite
* Analyze IT requirements from multiple sources to assist with planning, procurement, and executive decision making.
* Create presentations and reports based on recommendations and findings for internal teams and/or external clients
* Use knowledge of FBI practices and methods to help guide the client in developing the technology needed to support the construction of next generation FBI facilities
* Ability to adapt quickly to changing needs and provide value across several core areas, including data modeling, database design and development, ETL (Extract, Transform, and Load) design and development, and data quality management techniques
* Design, deploy, and maintain data within cloud environments including MS-SQL Server
* Write and debug custom SQL queries using tools such as SQL Developer
* Manage multiple parallel assignments within an agile framework and meet specified milestones
* Provide technical expertise in the diagnosis and resolution of issues, including the determination and provision of workaround solutions, escalation to owners, and communication to project manager
* Ensure delivered solutions meets technical and functional/non-functional performance requirements
* Work in a client-facing role in a consulting environment among mid-level to senior leadership
* Build strong working relationships and manage and resolve client and team challenges What You Will Need : * The ability to obtain and maintain a TOP SECRET federal security clearance.
* Bachelor's Degree
* THREE (3) or more years of experience working with data analysis, data visualization or Power Apps development What Would Be Nice To Have : * Creative and Analytical Thinking: Must have a strong grounding in statistical methods with the ability to think through problems with a creative and analytical lens.
* O365 Integration and Power Platform: Should have a working knowledge of and experience with Microsoft O365 and Power Platform Suites (Power BI, Power Automate, Power Apps, Word, Excel, PowerPoint, SharePoint) and data integration within the suites.
* Strong and Effective Communication: Should be able to convey findings and information in a clear and concise manner to team members, Leadership, and executives.
* Data Visualization: Should have working knowledge of the effective use of data visualization and an understanding of what types of graphs effectively display the data, how to scale visualizations, and which charts to use depending on their audience.
* SQL Databases: Should have working knowledge of MS SQL Server 2019 and SQL Server Management Studio, as well as common querying languages such as PostgreSQL, T-SQL, and PL/SQL
* Data Warehousing: Should have working knowledge with Data warehousing or data lakes and be able to connect databases from multiple sources and streams in a central data warehouse or data lake.
* Prior experience with designing and implementing data pipelines or ETL processes
* Prior experience with using machine learning to process large data sets
* Prior experience working in federal environment
* Programming Languages: Should be proficient in at least one programming language such as R, Python, or SAS and have working knowledge of others for data gathering, data cleaning, statistical analysis, and data visualization.
* AI Builder experience
* UI/UX design concepts and practice What We Offer : Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace. Benefits include: * Medical, Rx, Dental & Vision Insurance
* Personal and Family Sick Time & Company Paid Holidays
* Position may be eligible for a discretionary variable incentive bonus
* Parental Leave and Adoption Assistance
* 401(k) Retirement Plan
* Basic Life & Supplemental Life
* Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
* Short-Term & Long-Term Disability
* Student Loan PayDown
* Tuition Reimbursement, Personal Development & Learning Opportunities
* Skills Development & Certifications
* Employee Referral Program
* Corporate Sponsored Events & Community Outreach
* Emergency Back-Up Childcare Program
* Mobility Stipend About Guidehouse Guidehouse is an Equal Employment Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other basis protected by law, ordinance, or regulation. Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco. If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.